﻿
Imports System.Data.OleDb


Public Class Lunch_details
    Inherits System.Web.UI.Page
    

        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

            Dim oleDbConn As New OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("Outletsdb").ConnectionString)

            oleDbConn.Open()
            Dim cmdQuery As String = "Select * From location"

            Dim dbComm = New OleDbCommand(cmdQuery, oleDbConn)
            Dim dbread = dbComm.ExecuteReader()

            While dbread.Read()
                Response.Write(dbread.Item("Area"))
                Response.Write(dbread.Item("Cuisines"))
            ' Pla#ceHolder1.Controls.add(New LiteralControl("Area"))
            'PlaceHolder1.Controls.add(New LiteralControl("Cuisines"))

            End While
        End Sub
    End Class
